<?php
require_once '../includes/dbcon.php';

// Check if user is logged in (adjust based on your authentication system)
if (!is_logged_in()) {
    redirect('login.php'); // Redirect to login if not authenticated
}

$title_options = [
    'History' => 'History',
    'Vision' => 'Vision',
    'Mission' => 'Mission',
    'Core Values' => 'Core Values',
    'Phones' => 'Phones',
    'Address' => 'Address',
    'Emails' => 'Emails'
];

// Initialize variables
$sn = $title = $content = '';
$error = $success = '';
$edit_mode = false;

// CSRF Token
$csrf_token = generate_csrf_token();

// Handle form submissions
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    if (!validate_csrf_token($_POST['csrf_token'])) {
        $error = "Security token validation failed.";
    } else {
        $title = sanitize_input($_POST['title']);
        $content = sanitize_input($_POST['content']);
        
        // Validation
        if (empty($title) || empty($content)) {
            $error = "Please fill in all fields.";
        } else {
            try {
                if (isset($_POST['update']) && isset($_POST['sn'])) {
                    // Update existing record
                    $sn = intval($_POST['sn']);
                    $stmt = $DBcon->prepare("UPDATE siteinfo SET title = :title, content = :content WHERE sn = :sn");
                    $stmt->bindParam(':sn', $sn, PDO::PARAM_INT);
                    $stmt->bindParam(':title', $title);
                    $stmt->bindParam(':content', $content);
                    
                    if ($stmt->execute()) {
                        $success = "Record updated successfully!";
                        $edit_mode = false;
                        $title = $content = '';
                    }
                } else {
                    // Insert new record
                    // Check if title already exists
                    $check_stmt = $DBcon->prepare("SELECT COUNT(*) FROM siteinfo WHERE title = :title");
                    $check_stmt->bindParam(':title', $title);
                    $check_stmt->execute();
                    
                    if ($check_stmt->fetchColumn() > 0) {
                        $error = "This title already exists. Please choose a different one or edit the existing record.";
                    } else {
                        $stmt = $DBcon->prepare("INSERT INTO siteinfo (title, content) VALUES (:title, :content)");
                        $stmt->bindParam(':title', $title);
                        $stmt->bindParam(':content', $content);
                        
                        if ($stmt->execute()) {
                            $success = "Record added successfully!";
                            $title = $content = '';
                        }
                    }
                }
            } catch(PDOException $e) {
                $error = "Database error: " . $e->getMessage();
            }
        }
    }
}

// Handle delete request
if (isset($_GET['delete']) && is_numeric($_GET['delete'])) {
    if (isset($_GET['csrf_token']) && validate_csrf_token($_GET['csrf_token'])) {
        try {
            $delete_id = intval($_GET['delete']);
            $stmt = $DBcon->prepare("DELETE FROM siteinfo WHERE sn = :sn");
            $stmt->bindParam(':sn', $delete_id, PDO::PARAM_INT);
            
            if ($stmt->execute()) {
                $success = "Record deleted successfully!";
            }
        } catch(PDOException $e) {
            $error = "Error deleting record: " . $e->getMessage();
        }
    } else {
        $error = "Security token validation failed for delete action.";
    }
}

// Handle edit request
if (isset($_GET['edit']) && is_numeric($_GET['edit'])) {
    try {
        $edit_id = intval($_GET['edit']);
        $stmt = $DBcon->prepare("SELECT * FROM siteinfo WHERE sn = :sn");
        $stmt->bindParam(':sn', $edit_id, PDO::PARAM_INT);
        $stmt->execute();
        
        if ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
            $sn = $row['sn'];
            $title = $row['title'];
            $content = $row['content'];
            $edit_mode = true;
        }
    } catch(PDOException $e) {
        $error = "Error loading record: " . $e->getMessage();
    }
}

// Fetch all records for display
try {
    $stmt = $DBcon->query("SELECT * FROM siteinfo ORDER BY 
        FIELD(title, 'History', 'Vision', 'Mission', 'Core Values', 'Phones', 'Address', 'Emails'),
        title");
    $records = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch(PDOException $e) {
    $error = "Error loading records: " . $e->getMessage();
    $records = [];
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  <title>Site Information Management</title>
  <link rel="stylesheet" href="vendors/iconfonts/font-awesome/css/all.min.css">
  <link rel="stylesheet" href="vendors/css/vendor.bundle.base.css">
  <link rel="stylesheet" href="vendors/css/vendor.bundle.addons.css">
  <link rel="stylesheet" href="css/style.css">
  <style>
    .content-wrapper {
      padding: 1.5rem;
    }
    
    .card {
      box-shadow: 0 0.125rem 0.625rem rgba(0, 0, 0, 0.1);
      border: none;
      border-radius: 10px;
      margin-bottom: 1.5rem;
    }
    
    .card-header {
      background: linear-gradient(135deg, #6a11cb 0%, #2575fc 100%);
      color: white;
      border-radius: 10px 10px 0 0 !important;
      padding: 1.25rem 1.5rem;
    }
    
    .btn-gradient {
      background: linear-gradient(135deg, #6a11cb 0%, #2575fc 100%);
      border: none;
      color: white;
      transition: all 0.3s ease;
    }
    
    .btn-gradient:hover {
      transform: translateY(-2px);
      box-shadow: 0 5px 15px rgba(106, 17, 203, 0.3);
      color: white;
    }
    
    .btn-danger-gradient {
      background: linear-gradient(135deg, #ff416c 0%, #ff4b2b 100%);
      border: none;
      color: white;
    }
    
    .alert {
      border-radius: 8px;
      border: none;
      padding: 1rem 1.5rem;
    }
    
    .table-responsive {
      border-radius: 8px;
      overflow: hidden;
    }
    
    .table {
      margin-bottom: 0;
    }
    
    .table th {
      border-top: none;
      background: #f8f9fa;
      font-weight: 600;
      color: #495057;
    }
    
    .table td {
      vertical-align: middle;
    }
    
    .form-control, .form-select {
      border-radius: 8px;
      border: 1px solid #e1e5eb;
      padding: 0.75rem 1rem;
    }
    
    .form-control:focus, .form-select:focus {
      border-color: #6a11cb;
      box-shadow: 0 0 0 0.2rem rgba(106, 17, 203, 0.1);
    }
    
    .action-buttons .btn {
      margin-right: 5px;
      border-radius: 6px;
      padding: 0.375rem 0.75rem;
      font-size: 0.875rem;
    }
    
    .preview-content {
      max-height: 100px;
      overflow: hidden;
      text-overflow: ellipsis;
      display: -webkit-box;
      -webkit-line-clamp: 3;
      -webkit-box-orient: vertical;
    }
    
    @media (max-width: 768px) {
      .action-buttons {
        display: flex;
        flex-direction: column;
      }
      
      .action-buttons .btn {
        margin-bottom: 5px;
        width: 100%;
      }
    }
  </style>
</head>
<body>
  <div class="container-scroller">
    <?php include("header.php"); ?>
    <div class="container-fluid page-body-wrapper">
      <?php include("sidebar.php"); ?>
      <div class="main-panel">
        <div class="content-wrapper">
          <div class="page-header">
            <h3 class="page-title">
              <i class="fas fa-info-circle text-primary mr-2"></i>
              Site Information Management
            </h3>
            <nav aria-label="breadcrumb">
              <ol class="breadcrumb">
                <li class="breadcrumb-item"><a href="master.php">Dashboard</a></li>
                <li class="breadcrumb-item active" aria-current="page">Site Info</li>
              </ol>
            </nav>
          </div>

          <!-- Messages -->
          <?php if ($error): ?>
          <div class="alert alert-danger alert-dismissible fade show" role="alert">
            <i class="fas fa-exclamation-circle mr-2"></i>
            <?php echo $error; ?>
            <button type="button" class="close" data-dismiss="alert" aria-label="Close">
              <span aria-hidden="true">&times;</span>
            </button>
          </div>
          <?php endif; ?>
          
          <?php if ($success): ?>
          <div class="alert alert-success alert-dismissible fade show" role="alert">
            <i class="fas fa-check-circle mr-2"></i>
            <?php echo $success; ?>
            <button type="button" class="close" data-dismiss="alert" aria-label="Close">
              <span aria-hidden="true">&times;</span>
            </button>
          </div>
          <?php endif; ?>

          <div class="row">
            <!-- Form Column -->
            <div class="col-md-4 grid-margin stretch-card">
              <div class="card">
                <div class="card-header">
                  <h4 class="card-title mb-0">
                    <i class="fas fa-<?php echo $edit_mode ? 'edit' : 'plus'; ?> mr-2"></i>
                    <?php echo $edit_mode ? 'Edit Information' : 'Add New Information'; ?>
                  </h4>
                </div>
                <div class="card-body">
                  <form method="POST" action="">
                    <input type="hidden" name="csrf_token" value="<?php echo $csrf_token; ?>">
                    <?php if ($edit_mode): ?>
                    <input type="hidden" name="sn" value="<?php echo $sn; ?>">
                    <?php endif; ?>
                    
                    <div class="form-group">
                      <label for="title">Title <span class="text-danger">*</span></label>
                      <select class="form-select" id="title" name="title" required <?php echo $edit_mode ? 'disabled' : ''; ?>>
                        <option value="">Select a title</option>
                        <?php foreach ($title_options as $key => $value): ?>
                        <option value="<?php echo $key; ?>" <?php echo ($title == $key) ? 'selected' : ''; ?>>
                          <?php echo $value; ?>
                        </option>
                        <?php endforeach; ?>
                      </select>
                      <?php if ($edit_mode): ?>
                      <small class="text-muted">Title cannot be changed in edit mode.</small>
                      <?php endif; ?>
                    </div>
                    
                    <div class="form-group">
                      <label for="content">Content <span class="text-danger">*</span></label>
                      <textarea class="form-control" id="content" name="content" rows="5" 
                                placeholder="Enter detailed content here..." required><?php echo $content; ?></textarea>
                    </div>
                    
                    <div class="form-group mt-4">
                      <?php if ($edit_mode): ?>
                      <button type="submit" name="update" class="btn btn-gradient btn-lg btn-block">
                        <i class="fas fa-save mr-2"></i> Update Information
                      </button>
                      <a href="siteinfo.php" class="btn btn-secondary btn-lg btn-block mt-2">
                        <i class="fas fa-times mr-2"></i> Cancel
                      </a>
                      <?php else: ?>
                      <button type="submit" name="submit" class="btn btn-gradient btn-lg btn-block">
                        <i class="fas fa-plus mr-2"></i> Add Information
                      </button>
                      <?php endif; ?>
                    </div>
                  </form>
                </div>
              </div>
            </div>

            <!-- List Column -->
            <div class="col-md-8 grid-margin stretch-card">
              <div class="card">
                <div class="card-header d-flex justify-content-between align-items-center">
                  <h4 class="card-title mb-0">
                    <i class="fas fa-list mr-2"></i>
                    Existing Information
                  </h4>
                  <span class="badge badge-light"><?php echo count($records); ?> records</span>
                </div>
                <div class="card-body">
                  <?php if (empty($records)): ?>
                  <div class="text-center py-5">
                    <i class="fas fa-info-circle fa-3x text-muted mb-3"></i>
                    <h5 class="text-muted">No information added yet</h5>
                    <p class="text-muted">Start by adding new information using the form on the left.</p>
                  </div>
                  <?php else: ?>
                  <div class="table-responsive">
                    <table class="table table-hover">
                      <thead>
                        <tr>
                          <th>SN</th>
                          <th>Title</th>
                          <th>Content Preview</th>
                          <th>Actions</th>
                        </tr>
                      </thead>
                      <tbody>
                        <?php foreach ($records as $record): ?>
                        <tr>
                          <td><?php echo $record['sn']; ?></td>
                          <td>
                            <span class="badge badge-info">
                              <i class="fas fa-tag mr-1"></i>
                              <?php echo htmlspecialchars($record['title']); ?>
                            </span>
                          </td>
                          <td>
                            <div class="preview-content">
                              <?php echo nl2br(htmlspecialchars(substr($record['content'], 0, 150))); ?>
                              <?php if (strlen($record['content']) > 150): ?>...<?php endif; ?>
                            </div>
                          </td>
                          <td class="action-buttons">
                            <a href="siteinfo.php?edit=<?php echo $record['sn']; ?>" 
                               class="btn btn-sm btn-outline-primary" title="Edit">
                              <i class="fas fa-edit"></i>
                            </a>
                            <a href="siteinfo.php?delete=<?php echo $record['sn']; ?>&csrf_token=<?php echo $csrf_token; ?>" 
                               class="btn btn-sm btn-outline-danger" 
                               title="Delete"
                               onclick="return confirm('Are you sure you want to delete this record?');">
                              <i class="fas fa-trash"></i>
                            </a>
                            <button type="button" class="btn btn-sm btn-outline-info" 
                                    title="View Full Content"
                                    onclick="viewContent(<?php echo $record['sn']; ?>, '<?php echo addslashes($record['title']); ?>', `<?php echo addslashes(nl2br(htmlspecialchars($record['content']))); ?>`)">
                              <i class="fas fa-eye"></i>
                            </button>
                          </td>
                        </tr>
                        <?php endforeach; ?>
                      </tbody>
                    </table>
                  </div>
                  <?php endif; ?>
                </div>
              </div>
            </div>
          </div>
        </div>

        <!-- Modal for viewing full content -->
        <div class="modal fade" id="contentModal" tabindex="-1" role="dialog">
          <div class="modal-dialog modal-lg" role="document">
            <div class="modal-content">
              <div class="modal-header">
                <h5 class="modal-title" id="modalTitle"></h5>
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                  <span aria-hidden="true">&times;</span>
                </button>
              </div>
              <div class="modal-body">
                <div id="modalContent"></div>
              </div>
              <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
              </div>
            </div>
          </div>
        </div>

        <footer class="footer">
          <div class="d-sm-flex justify-content-center justify-content-sm-between">
            <span class="text-muted text-center text-sm-left d-block d-sm-inline-block">
              Site Information Management System
            </span>
            <span class="float-none float-sm-right d-block mt-1 mt-sm-0 text-center">
              <i class="fas fa-code text-primary"></i> Powered by MMGSS Admin
            </span>
          </div>
        </footer>
      </div>
    </div>
  </div>

  <script src="vendors/js/vendor.bundle.base.js"></script>
  <script src="vendors/js/vendor.bundle.addons.js"></script>
  <script src="js/off-canvas.js"></script>
  <script src="js/hoverable-collapse.js"></script>
  <script src="js/misc.js"></script>
  <script>
    function viewContent(sn, title, content) {
      document.getElementById('modalTitle').innerHTML = '<i class="fas fa-info-circle mr-2"></i>' + title;
      document.getElementById('modalContent').innerHTML = content;
      $('#contentModal').modal('show');
    }
    
    // Auto-hide alerts after 5 seconds
    setTimeout(function() {
      $('.alert').alert('close');
    }, 5000);
    
    // Character counter for content textarea
    document.getElementById('content')?.addEventListener('input', function() {
      const charCount = this.value.length;
      const counter = document.getElementById('charCounter') || 
                      (() => {
                        const div = document.createElement('div');
                        div.id = 'charCounter';
                        div.className = 'text-muted text-end small mt-1';
                        this.parentNode.appendChild(div);
                        return div;
                      })();
      counter.textContent = charCount + ' characters';
    });
  </script>
</body>
</html>